package com.xunyin.modules.mtopencity.service.mapper;

import com.xunyin.common.mapper.CoreMapper;
import com.xunyin.modules.mtopencity.domain.MtOpenCity;
import com.xunyin.modules.mtopencity.service.vo.OpenCityVo;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * 开通城市 Mapper 接口
 * <p>
 * Created by xunyin
 * CopyRight 讯音云商 https://www.tonetn.com
 */
@Repository
public interface MtOpenCityMapper extends CoreMapper<MtOpenCity> {

    @Select("SELECT city_name as city,lng,lat,city_code as cityCode from mt_open_city where open_status = 1 and is_del=0 ")
    List<OpenCityVo> getOpenCityList();
}
